<?php
class Brand{
    protected $main_table = 'data_brand';
	protected $main_table2 = 'data_brand_cate';	
	protected $main_id = 'brand_id';
	protected $main_id2 = 'cate_id';	
	protected $db = null;
	
	public function __construct($db){
		$this->db=$db;
	}
   
	public function __destruct(){
		unset($this->db);
	}
	public function get_table_name(){
	    return $this->main_table;
	    
	}
	public function get_table_name2(){
	    return $this->main_table2;
	    
	}
	
	/**
	* 	insert brand
	* 	@param array $data 
	* 	@return int affected count
	*/
	public function insert_data($data){
		if(!is_array($data))
		my_jump('输入的参数有误');
		$rows = $this->db->insert($this->main_table, $data);
		$insert_id = $this->db->getInsertId();
		$this->update_file();
		return $insert_id;	
	}	
	
	/**
	* 	update brand
	* 	@param array $data 
	* 	@param string $where 
	* 	@return int affected count
	*/
	public function update_data($data,$where){
		if(!is_array($data))
		my_jump('输入的参数有误');
		$result = $this->db->update($this->main_table,$data,$where);
		$this->update_file();
		return $result;
	}
	
	/**
	* 	delete brand
	* 	@param string $where 
	* 	@return int affected count
	*/
	public function del_data($id){
		$result = $this->db->delete($this->main_table,$this->main_id."='".intval($id)."' ");
		$this->update_file();
		return $result;
	}	
	
	/**
	* 	get brand info
	* 	@param int $id 
	*	@param array/string $field
	* 	@return array one row data
	*/
	public function get_data_row($id,$field='*'){
		if(!intval($id))
		my_jump('输入的参数有误!');
		$sql = "SELECT ".$field." FROM ".$this->main_table." WHERE ".$this->main_id."='".intval($id)."' ";
		$data = $this->db->getRow($sql);
		return $data;
	}	
	
	/**
	* 	get brand array
	* 	@param string $where
	* 	@return array data
	*/
	public function get_data_array($where,$order='brand_id DESC',$limit='10',$field='*'){
		$sql = "SELECT ".$field." FROM ".$this->main_table." WHERE ".$where." ORDER BY ".$order;
		if(intval($limit)){
			$sql .= " LIMIT ".$limit;
		}
		$data = $this->db->getAll($sql);
		return $data;
	}  
	
	public function update_file(){
		$data = $this->get_data_array("1",'brand_id DESC','','brand_id,brand_name');		
		if($data){
			$temp_ary = array();
			foreach($data as $k=>$v){
				$temp_ary[$v['brand_id']] = $v['brand_name'];
			}			
			$new_array = '$cf_brand=';
			$new_array .= var_export($temp_ary,true);
			write_file(INFO_PATH.'cf_brand.php',$new_array,"php");		
		}
		
	} 
	
	
	/**
	* 	insert brand cate
	* 	@param array $data 
	* 	@return int affected count
	*/
	public function insert_data_cate($data){
		if(!is_array($data))
		my_jump('输入的参数有误');
		$rows = $this->db->insert($this->main_table2, $data);
		$insert_id = $this->db->getInsertId();
		$this->update_cate_file();
		return $insert_id;	
	}	
	
		/**
	* 	update brand cate
	* 	@param array $data 
	* 	@param string $where 
	* 	@return int affected count
	*/
	public function update_data_cate($data,$where){
		if(!is_array($data))
		my_jump('输入的参数有误');
		$result = $this->db->update($this->main_table2,$data,$where);
		$this->update_cate_file();
		return $result;
	}
	
	
	/**
	* 	get  brand cate info
	* 	@param int $id 
	*	@param array/string $field
	* 	@return array one row data
	*/
	public function get_cate_row($id,$field='*'){
		if(!intval($id))
		my_jump('输入的参数有误!');
		$sql = "SELECT ".$field." FROM ".$this->main_table2." WHERE ".$this->main_id2."='".intval($id)."' ";
		$data = $this->db->getRow($sql);
		return $data;
	}
	
		/**
	* 	update  update_cate_file
	* 	@param array $data 
	* 	@param string $where 
	* 	@return int affected count
	*/
	public function update_cate_file(){
		$cate_list = $this->get_cate_array('1');
		$temp_ary = array();
		foreach($cate_list as $v){
			$temp_ary[$v['cate_id']] = $v['cate_name'];
		}
		$new_array = "\$brand_cate=";
		$new_array .= var_export($temp_ary,true);
		write_file(INFO_PATH.'cf_brand_cate.php',$new_array,"php");	
	}
	
	/**
	* 	delete brand cate
	* 	@param string $where 
	* 	@return int affected count
	*/
	public function del_data_cate($id){
		$result = $this->db->delete($this->main_table2,$this->main_id2."='".intval($id)."' ");
		$this->update_cate_file();
		return $result;
	}
	
	
	/**
	* 	get brand array
	* 	@param string $where
	* 	@return array data
	*/
	public function get_cate_array($where,$order='cate_sort_num ASC',$field='*'){
		$sql = "SELECT ".$field." FROM ".$this->main_table2." WHERE ".$where." ORDER BY ".$order;		
		$data = $this->db->getAll($sql);
		return $data;
	} 

	//手机端的文章列表
	public function get_brand_list($where,$page,$order="brand_id DESC",$field="*",$pageCount=10){
		$sql = "SELECT ".$field." FROM ".$this->main_table." WHERE ".$where." ORDER BY ".$order." LIMIT ".($page-1)*$pageCount.",".$pageCount;		
		$list = $this->db->getAll($sql);		
		return $list;
	}

}

?>